ORACLE_9: Executed: on connection 1
CREATE TABLE bernie2 as select TXT_1."FIELD1" from BERNIE1 TXT_1 where (
TXT_1."FIELD1" is  NULL  or TXT_1."FIELD1" = 101 thru^ 103 or
(TXT_1."FIELD1" >= 101 and TXT_1."FIELD1" < 103) )

ORACLE:  *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-*
ERROR: ORACLE execute error: ORA-00907: missing right parenthesis.

DB2_10: Executed: on connection 1
CREATE  TABLE bernie2 as ( select TXT_1."FIELD1" from BERNIE1 TXT_1 where (
            TXT_1."FIELD1" is  NULL  or TXT_1."FIELD1" = 101 thru^ 103 or
            (TXT_1."FIELD1" >= 101 and TXT_1."FIELD1" < 103) ) ) WITH NO
            DATA

 DB2 ERROR:
 RESULT OF SQL STATEMENT:
 DSN00104E ILLEGAL SYMBOL "THRU". SOME SYMBOLS THAT MIGHT BE LEGAL ARE:
            MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE HOURS
 A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
           ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0
           SQLCODE: -104 SQLSTATE: 42601 SQLERRP: DSNHPARS

TERADATA_26: Executed: on connection 1
CREATE MULTISET TABLE "bernie2" as ( select TXT_1."field1", TXT_1."field2",
TXT_1."field3",
TXT_1."field4" from "bernie1" TXT_1 where ( TXT_1."field4" is  NULL  or
TXT_1."field4" = 101
thru^ 103 or (TXT_1."field4" >= 101 and TXT_1."field4" < 103) ) ) WITH DATA

TERADATA: trforc: COMMIT WORK
TERADATA: trforc: COMMIT WORK
ERROR: Teradata execute: Syntax error, expected something like an 'OR' keyword
or ')' between an
       integer and the word 'thru'.
SQL_IP_TRACE: Some of the SQL was directly passed to the DBMS.
TERADATA: trforc: COMMIT WORK

WHERE ((field1 >= 101) AND (field1 < 103)) or field1 is null